Tabela PhAuctionPackageOfferItem

Definicja tabeli PhAuctionPackageOfferItem

Name

PhAuctionPackageOfferItem

Code

PhAuctionPackageOfferItem

Comment

Pozycja pakietu oferty


Lista kolumn tabeli PhAuctionPackageOfferItem

Name

Code

AuctionPackageOfferItemID

AuctionPackageOfferItemID

VatRateId

VatRateId

Quantity

Quantity

PriceGross

PriceGross

PriceNet

PriceNet

VatAmount

VatAmount

ValueGross

ValueGross

tradeName

tradeName

ProducerID

ProducerID

AuctionPackageItemID

AuctionPackageItemID

StockItemID

StockItemID

AuctionPackageOfferID

AuctionPackageOfferID

Valid

Valid_


Kolumna AuctionPackageOfferItemID tabeli PhAuctionPackageOfferItem

Definicja kolumny AuctionPackageOfferItemID tabeli PhAuctionPackageOfferItem

Name

AuctionPackageOfferItemID

Code

AuctionPackageOfferItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Klucz


Kolumna VatRateId tabeli PhAuctionPackageOfferItem

Definicja kolumny VatRateId tabeli PhAuctionPackageOfferItem

Name

VatRateId

Code

VatRateId

Data Type

NUMBER(10)

Mandatory

No

Comment

vat fk do tabeli VATRate


Kolumna Quantity tabeli PhAuctionPackageOfferItem

Definicja kolumny Quantity tabeli PhAuctionPackageOfferItem

Name

Quantity

Code

Quantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

ilosc ofertowa


Kolumna PriceGross tabeli PhAuctionPackageOfferItem

Definicja kolumny PriceGross tabeli PhAuctionPackageOfferItem

Name

PriceGross

Code

PriceGross

Data Type

NUMBER(19,8)

Mandatory

No

Comment

cena brutto za pozycje


Kolumna PriceNet tabeli PhAuctionPackageOfferItem

Definicja kolumny PriceNet tabeli PhAuctionPackageOfferItem

Name

PriceNet

Code

PriceNet

Data Type

NUMBER(19,8)

Mandatory

No

Comment

cena netto za pozycje


Kolumna VatAmount tabeli PhAuctionPackageOfferItem

Definicja kolumny VatAmount tabeli PhAuctionPackageOfferItem

Name

VatAmount

Code

VatAmount

Data Type

NUMBER(19,8)

Mandatory

No

Comment

wartosc vat


Kolumna ValueGross tabeli PhAuctionPackageOfferItem

Definicja kolumny ValueGross tabeli PhAuctionPackageOfferItem

Name

ValueGross

Code

ValueGross

Data Type

NUMBER(19,8)

Mandatory

No

Comment

wartosc brutto


Kolumna tradeName tabeli PhAuctionPackageOfferItem

Definicja kolumny tradeName tabeli PhAuctionPackageOfferItem

Name

tradeName

Code

tradeName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Nazwa handlowa oferowanego towaru


Kolumna ProducerID tabeli PhAuctionPackageOfferItem

Definicja kolumny ProducerID tabeli PhAuctionPackageOfferItem

Name

ProducerID

Code

ProducerID

Data Type

NUMBER(10)

Mandatory

No

Comment

Producent oferowanego towaru fk do tabeli PhCompany


Kolumna AuctionPackageItemID tabeli PhAuctionPackageOfferItem

Definicja kolumny AuctionPackageItemID tabeli PhAuctionPackageOfferItem

Name

AuctionPackageItemID

Code

AuctionPackageItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

Powiazanie z pozycja przetargowa której
dotyczy pozycja ofertowa fk do tabeli PhAuctionPackageItem


Kolumna StockItemID tabeli PhAuctionPackageOfferItem

Definicja kolumny StockItemID tabeli PhAuctionPackageOfferItem

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

Karta asortymentowa klucz fk do tabeli PhStItem


Kolumna AuctionPackageOfferID tabeli PhAuctionPackageOfferItem

Definicja kolumny AuctionPackageOfferID tabeli PhAuctionPackageOfferItem

Name

AuctionPackageOfferID

Code

AuctionPackageOfferID

Data Type

NUMBER(10)

Mandatory

No

Comment

Pakiet ofertowy którego dotyczy dana
pozycja ofertowa fk do PhAuctionPackageOffer


Kolumna Valid tabeli PhAuctionPackageOfferItem

Definicja kolumny Valid tabeli PhAuctionPackageOfferItem

Name

Valid

Code

Valid_

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy pozycja spelnia wymagania przetargowe


Lista kluczy tabeli PhAuctionPackageOfferItem

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhAuctionPackageOfferItem

Definicja klucza Identifier_1 tabeli PhAuctionPackageOfferItem

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment